Dataset info
| Number of variables | 21 |
|---|---|
| Number of observations | 21597 |
| Missing cells | 6281 (1.4%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 3.5 MiB |
| Average record size in memory | 168.0 B |
Variables types
| Numeric | 18 |
|---|---|
| Categorical | 2 |
| Boolean | 1 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 0 |
| Rejected | 0 |
| Unsupported | 0 |
Warnings
date has a high cardinality: 372 distinct values | Warning |
sqft_basement has a high cardinality: 304 distinct values | Warning |
view has 19422 (89.9%) zeros | Zeros |
waterfront has 2376 (11.0%) missing values | Missing |
yr_renovated has 17011 (78.8%) zeros | Zeros |
yr_renovated has 3842 (17.8%) missing values | Missing |
bathrooms
Numeric
| Distinct count | 29 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.115826272 |
|---|---|
| Minimum | 0.5 |
| Maximum | 8 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 0.5 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1.75 |
| Median | 2.25 |
| Q3 | 2.5 |
| 95-th percentile | 3.5 |
| Maximum | 8 |
| Range | 7.5 |
| Interquartile range | 0.75 |
Descriptive statistics
| Standard deviation | 0.7689842967 |
|---|---|
| Coef of variation | 0.3634439683 |
| Kurtosis | 1.279315294 |
| Mean | 2.115826272 |
| MAD | 0.6145972614 |
| Skewness | 0.5197092816 |
| Sum | 45695.5 |
| Variance | 0.5913368485 |
| Memory size | 168.9 KiB |
| Value | Count | Frequency (%) | |
| 2.5 | 5377 | 24.9% | |
| 1 | 3851 | 17.8% | |
| 1.75 | 3048 | 14.1% | |
| 2.25 | 2047 | 9.5% | |
| 2 | 1930 | 8.9% | |
| 1.5 | 1445 | 6.7% | |
| 2.75 | 1185 | 5.5% | |
| 3 | 753 | 3.5% | |
| 3.5 | 731 | 3.4% | |
| 3.25 | 589 | 2.7% | |
| Other values (19) | 641 | 3.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.5 | 4 | < 0.1% | |
| 0.75 | 71 | 0.3% | |
| 1 | 3851 | 17.8% | |
| 1.25 | 9 | < 0.1% | |
| 1.5 | 1445 | 6.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 8 | 2 | < 0.1% | |
| 7.75 | 1 | < 0.1% | |
| 7.5 | 1 | < 0.1% | |
| 6.75 | 2 | < 0.1% | |
| 6.5 | 2 | < 0.1% |
bedrooms
Numeric
| Distinct count | 12 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.373199981 |
|---|---|
| Minimum | 1 |
| Maximum | 33 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 3 |
| Median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 33 |
| Range | 32 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 0.9262988945 |
|---|---|
| Coef of variation | 0.2746053894 |
| Kurtosis | 49.82183475 |
| Mean | 3.373199981 |
| MAD | 0.7335737152 |
| Skewness | 2.023641235 |
| Sum | 72851 |
| Variance | 0.858029642 |
| Memory size | 168.9 KiB |
| Value | Count | Frequency (%) | |
| 3 | 9824 | 45.5% | |
| 4 | 6882 | 31.9% | |
| 2 | 2760 | 12.8% | |
| 5 | 1601 | 7.4% | |
| 6 | 272 | 1.3% | |
| 1 | 196 | 0.9% | |
| 7 | 38 | 0.2% | |
| 8 | 13 | 0.1% | |
| 9 | 6 | < 0.1% | |
| 10 | 3 | < 0.1% | |
| Other values (2) | 2 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 196 | 0.9% | |
| 2 | 2760 | 12.8% | |
| 3 | 9824 | 45.5% | |
| 4 | 6882 | 31.9% | |
| 5 | 1601 | 7.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 33 | 1 | < 0.1% | |
| 11 | 1 | < 0.1% | |
| 10 | 3 | < 0.1% | |
| 9 | 6 | < 0.1% | |
| 8 | 13 | 0.1% |
condition
Numeric
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.409825439 |
|---|---|
| Minimum | 1 |
| Maximum | 5 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 3 |
| Median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 0.6505456357 |
|---|---|
| Coef of variation | 0.1907856127 |
| Kurtosis | 0.5192374924 |
| Mean | 3.409825439 |
| MAD | 0.5607545412 |
| Skewness | 1.036037425 |
| Sum | 73642 |
| Variance | 0.4232096241 |
| Memory size | 168.9 KiB |
| Value | Count | Frequency (%) | |
| 3 | 14020 | 64.9% | |
| 4 | 5677 | 26.3% | |
| 5 | 1701 | 7.9% | |
| 2 | 170 | 0.8% | |
| 1 | 29 | 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 29 | 0.1% | |
| 2 | 170 | 0.8% | |
| 3 | 14020 | 64.9% | |
| 4 | 5677 | 26.3% | |
| 5 | 1701 | 7.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 5 | 1701 | 7.9% | |
| 4 | 5677 | 26.3% | |
| 3 | 14020 | 64.9% | |
| 2 | 170 | 0.8% | |
| 1 | 29 | 0.1% |
date
Categorical
| Distinct count | 372 |
|---|---|
| Unique (%) | 1.7% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 6/23/2014 | 142 |
|---|---|
| 6/25/2014 | 131 |
| 6/26/2014 | 131 |
| Other values (369) |
| Value | Count | Frequency (%) | |
| 6/23/2014 | 142 | 0.7% | |
| 6/25/2014 | 131 | 0.6% | |
| 6/26/2014 | 131 | 0.6% | |
| 7/8/2014 | 127 | 0.6% | |
| 4/27/2015 | 126 | 0.6% | |
| 3/25/2015 | 123 | 0.6% | |
| 7/9/2014 | 121 | 0.6% | |
| 4/28/2015 | 121 | 0.6% | |
| 4/22/2015 | 121 | 0.6% | |
| 4/14/2015 | 121 | 0.6% | |
| Other values (362) | 20333 | 94.1% |
| Max length | 10 |
|---|---|
| Mean length | 8.924433949 |
| Min length | 8 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
floors
Numeric
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.494096402 |
|---|---|
| Minimum | 1 |
| Maximum | 3.5 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1.5 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 3.5 |
| Range | 2.5 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 0.539682791 |
|---|---|
| Coef of variation | 0.3612101536 |
| Kurtosis | -0.4910657592 |
| Mean | 1.494096402 |
| MAD | 0.4883540215 |
| Skewness | 0.6144969756 |
| Sum | 32268 |
| Variance | 0.2912575149 |
| Memory size | 168.9 KiB |
| Value | Count | Frequency (%) | |
| 1 | 10673 | 49.4% | |
| 2 | 8235 | 38.1% | |
| 1.5 | 1910 | 8.8% | |
| 3 | 611 | 2.8% | |
| 2.5 | 161 | 0.7% | |
| 3.5 | 7 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 10673 | 49.4% | |
| 1.5 | 1910 | 8.8% | |
| 2 | 8235 | 38.1% | |
| 2.5 | 161 | 0.7% | |
| 3 | 611 | 2.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3.5 | 7 | < 0.1% | |
| 3 | 611 | 2.8% | |
| 2.5 | 161 | 0.7% | |
| 2 | 8235 | 38.1% | |
| 1.5 | 1910 | 8.8% |
grade
Numeric
| Distinct count | 11 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 7.657915451 |
|---|---|
| Minimum | 3 |
| Maximum | 13 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 7 |
| Median | 7 |
| Q3 | 8 |
| 95-th percentile | 10 |
| Maximum | 13 |
| Range | 10 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 1.173199664 |
|---|---|
| Coef of variation | 0.1532009163 |
| Kurtosis | 1.135148022 |
| Mean | 7.657915451 |
| MAD | 0.9287958624 |
| Skewness | 0.7882366364 |
| Sum | 165388 |
| Variance | 1.376397451 |
| Memory size | 168.9 KiB |
| Value | Count | Frequency (%) | |
| 7 | 8974 | 41.6% | |
| 8 | 6065 | 28.1% | |
| 9 | 2615 | 12.1% | |
| 6 | 2038 | 9.4% | |
| 10 | 1134 | 5.3% | |
| 11 | 399 | 1.8% | |
| 5 | 242 | 1.1% | |
| 12 | 89 | 0.4% | |
| 4 | 27 | 0.1% | |
| 13 | 13 | 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 3 | 1 | < 0.1% | |
| 4 | 27 | 0.1% | |
| 5 | 242 | 1.1% | |
| 6 | 2038 | 9.4% | |
| 7 | 8974 | 41.6% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 13 | 13 | 0.1% | |
| 12 | 89 | 0.4% | |
| 11 | 399 | 1.8% | |
| 10 | 1134 | 5.3% | |
| 9 | 2615 | 12.1% |
id
Numeric
| Distinct count | 21420 |
|---|---|
| Unique (%) | 99.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 4580474288 |
|---|---|
| Minimum | 1000102 |
| Maximum | 9900000190 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1000102 |
|---|---|
| 5-th percentile | 512740390 |
| Q1 | 2123049175 |
| Median | 3904930410 |
| Q3 | 7308900490 |
| 95-th percentile | 9297300412 |
| Maximum | 9900000190 |
| Range | 9899000088 |
| Interquartile range | 5185851315 |
Descriptive statistics
| Standard deviation | 2876735716 |
|---|---|
| Coef of variation | 0.6280431971 |
| Kurtosis | -1.260749894 |
| Mean | 4580474288 |
| MAD | 2543785476 |
| Skewness | 0.243225522 |
| Sum | 9.892450319e+13 |
| Variance | 8.275608378e+18 |
| Memory size | 168.9 KiB |
| Value | Count | Frequency (%) | |
| 795000620 | 3 | < 0.1% | |
| 1825069031 | 2 | < 0.1% | |
| 2019200220 | 2 | < 0.1% | |
| 7129304540 | 2 | < 0.1% | |
| 1781500435 | 2 | < 0.1% | |
| 3969300030 | 2 | < 0.1% | |
| 2560801222 | 2 | < 0.1% | |
| 3883800011 | 2 | < 0.1% | |
| 2228900270 | 2 | < 0.1% | |
| 251300110 | 2 | < 0.1% | |
| Other values (21410) | 21576 | 99.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1000102 | 2 | < 0.1% | |
| 1200019 | 1 | < 0.1% | |
| 1200021 | 1 | < 0.1% | |
| 2800031 | 1 | < 0.1% | |
| 3600057 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 9900000190 | 1 | < 0.1% | |
| 9895000040 | 1 | < 0.1% | |
| 9842300540 | 1 | < 0.1% | |
| 9842300485 | 1 | < 0.1% | |
| 9842300095 | 1 | < 0.1% |
lat
Numeric
| Distinct count | 5033 |
|---|---|
| Unique (%) | 23.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 47.56009299 |
|---|---|
| Minimum | 47.1559 |
| Maximum | 47.7776 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 47.1559 |
|---|---|
| 5-th percentile | 47.3103 |
| Q1 | 47.4711 |
| Median | 47.5718 |
| Q3 | 47.678 |
| 95-th percentile | 47.7497 |
| Maximum | 47.7776 |
| Range | 0.6217 |
| Interquartile range | 0.2069 |
Descriptive statistics
| Standard deviation | 0.1385517682 |
|---|---|
| Coef of variation | 0.002913193803 |
| Kurtosis | -0.6757902106 |
| Mean | 47.56009299 |
| MAD | 0.1148176747 |
| Skewness | -0.48552159 |
| Sum | 1027155.328 |
| Variance | 0.01919659246 |
| Memory size | 168.9 KiB |
| Value | Count | Frequency (%) | |
| 47.6624 | 17 | 0.1% | |
| 47.5491 | 17 | 0.1% | |
| 47.5322 | 17 | 0.1% | |
| 47.6846 | 17 | 0.1% | |
| 47.6711 | 16 | 0.1% | |
| 47.6886 | 16 | 0.1% | |
| 47.6955 | 16 | 0.1% | |
| 47.6647 | 15 | 0.1% | |
| 47.6904 | 15 | 0.1% | |
| 47.686 | 15 | 0.1% | |
| Other values (5023) | 21436 | 99.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 47.1559 | 1 | < 0.1% | |
| 47.1593 | 1 | < 0.1% | |
| 47.1622 | 1 | < 0.1% | |
| 47.1647 | 1 | < 0.1% | |
| 47.1764 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 47.7776 | 3 | < 0.1% | |
| 47.7775 | 3 | < 0.1% | |
| 47.7774 | 1 | < 0.1% | |
| 47.7772 | 3 | < 0.1% | |
| 47.7771 | 2 | < 0.1% |
long
Numeric
| Distinct count | 751 |
|---|---|
| Unique (%) | 3.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | -122.2139825 |
|---|---|
| Minimum | -122.519 |
| Maximum | -121.315 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | -122.519 |
|---|---|
| 5-th percentile | -122.387 |
| Q1 | -122.328 |
| Median | -122.231 |
| Q3 | -122.125 |
| 95-th percentile | -121.9798 |
| Maximum | -121.315 |
| Range | 1.204 |
| Interquartile range | 0.203 |
Descriptive statistics
| Standard deviation | 0.1407235288 |
|---|---|
| Coef of variation | -0.001151451953 |
| Kurtosis | 1.052120317 |
| Mean | -122.2139825 |
| MAD | 0.1150902288 |
| Skewness | 0.8848883395 |
| Sum | -2639455.38 |
| Variance | 0.01980311157 |
| Memory size | 168.9 KiB |
| Value | Count | Frequency (%) | |
| -122.29 | 115 | 0.5% | |
| -122.3 | 111 | 0.5% | |
| -122.362 | 104 | 0.5% | |
| -122.291 | 100 | 0.5% | |
| -122.372 | 99 | 0.5% | |
| -122.363 | 99 | 0.5% | |
| -122.288 | 98 | 0.5% | |
| -122.357 | 96 | 0.4% | |
| -122.284 | 95 | 0.4% | |
| -122.172 | 94 | 0.4% | |
| Other values (741) | 20586 | 95.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -122.519 | 1 | < 0.1% | |
| -122.515 | 1 | < 0.1% | |
| -122.514 | 1 | < 0.1% | |
| -122.512 | 1 | < 0.1% | |
| -122.511 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| -121.315 | 2 | < 0.1% | |
| -121.316 | 1 | < 0.1% | |
| -121.319 | 1 | < 0.1% | |
| -121.321 | 1 | < 0.1% | |
| -121.325 | 1 | < 0.1% |
price
Numeric
| Distinct count | 3622 |
|---|---|
| Unique (%) | 16.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 540296.5735 |
|---|---|
| Minimum | 78000 |
| Maximum | 7700000 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 78000 |
|---|---|
| 5-th percentile | 210000 |
| Q1 | 322000 |
| Median | 450000 |
| Q3 | 645000 |
| 95-th percentile | 1160000 |
| Maximum | 7700000 |
| Range | 7622000 |
| Interquartile range | 323000 |
Descriptive statistics
| Standard deviation | 367368.1401 |
|---|---|
| Coef of variation | 0.6799379417 |
| Kurtosis | 34.54135858 |
| Mean | 540296.5735 |
| MAD | 234028.1757 |
| Skewness | 4.023364652 |
| Sum | 1.16687851e+10 |
| Variance | 1.349593504e+11 |
| Memory size | 168.9 KiB |
| Value | Count | Frequency (%) | |
| 350000 | 172 | 0.8% | |
| 450000 | 172 | 0.8% | |
| 550000 | 159 | 0.7% | |
| 500000 | 152 | 0.7% | |
| 425000 | 150 | 0.7% | |
| 325000 | 148 | 0.7% | |
| 400000 | 145 | 0.7% | |
| 375000 | 138 | 0.6% | |
| 300000 | 133 | 0.6% | |
| 525000 | 131 | 0.6% | |
| Other values (3612) | 20097 | 93.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 78000 | 1 | < 0.1% | |
| 80000 | 1 | < 0.1% | |
| 81000 | 1 | < 0.1% | |
| 82000 | 1 | < 0.1% | |
| 82500 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 7700000 | 1 | < 0.1% | |
| 7060000 | 1 | < 0.1% | |
| 6890000 | 1 | < 0.1% | |
| 5570000 | 1 | < 0.1% | |
| 5350000 | 1 | < 0.1% |
sqft_above
Numeric
| Distinct count | 942 |
|---|---|
| Unique (%) | 4.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1788.596842 |
|---|---|
| Minimum | 370 |
| Maximum | 9410 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 370 |
|---|---|
| 5-th percentile | 850 |
| Q1 | 1190 |
| Median | 1560 |
| Q3 | 2210 |
| 95-th percentile | 3400 |
| Maximum | 9410 |
| Range | 9040 |
| Interquartile range | 1020 |
Descriptive statistics
| Standard deviation | 827.7597612 |
|---|---|
| Coef of variation | 0.4627984024 |
| Kurtosis | 3.405519761 |
| Mean | 1788.596842 |
| MAD | 640.1909905 |
| Skewness | 1.447434235 |
| Sum | 38628326 |
| Variance | 685186.2222 |
| Memory size | 168.9 KiB |
| Value | Count | Frequency (%) | |
| 1300 | 212 | 1.0% | |
| 1010 | 210 | 1.0% | |
| 1200 | 206 | 1.0% | |
| 1220 | 192 | 0.9% | |
| 1140 | 184 | 0.9% | |
| 1400 | 180 | 0.8% | |
| 1060 | 178 | 0.8% | |
| 1180 | 177 | 0.8% | |
| 1340 | 176 | 0.8% | |
| 1250 | 174 | 0.8% | |
| Other values (932) | 19708 | 91.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 370 | 1 | < 0.1% | |
| 380 | 1 | < 0.1% | |
| 390 | 1 | < 0.1% | |
| 410 | 1 | < 0.1% | |
| 420 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 9410 | 1 | < 0.1% | |
| 8860 | 1 | < 0.1% | |
| 8570 | 1 | < 0.1% | |
| 8020 | 1 | < 0.1% | |
| 7880 | 1 | < 0.1% |
sqft_basement
Categorical
| Distinct count | 304 |
|---|---|
| Unique (%) | 1.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0.0 | |
|---|---|
| ? | 454 |
| 600.0 | 217 |
| Other values (301) |
| Value | Count | Frequency (%) | |
| 0.0 | 12826 | 59.4% | |
| ? | 454 | 2.1% | |
| 600.0 | 217 | 1.0% | |
| 500.0 | 209 | 1.0% | |
| 700.0 | 208 | 1.0% | |
| 800.0 | 201 | 0.9% | |
| 400.0 | 184 | 0.9% | |
| 1000.0 | 148 | 0.7% | |
| 300.0 | 142 | 0.7% | |
| 900.0 | 142 | 0.7% | |
| Other values (294) | 6866 | 31.8% |
| Max length | 6 |
|---|---|
| Mean length | 3.816039265 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
sqft_living
Numeric
| Distinct count | 1034 |
|---|---|
| Unique (%) | 4.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2080.32185 |
|---|---|
| Minimum | 370 |
| Maximum | 13540 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 370 |
|---|---|
| 5-th percentile | 940 |
| Q1 | 1430 |
| Median | 1910 |
| Q3 | 2550 |
| 95-th percentile | 3760 |
| Maximum | 13540 |
| Range | 13170 |
| Interquartile range | 1120 |
Descriptive statistics
| Standard deviation | 918.1061251 |
|---|---|
| Coef of variation | 0.4413288862 |
| Kurtosis | 5.252101951 |
| Mean | 2080.32185 |
| MAD | 698.0845425 |
| Skewness | 1.473215455 |
| Sum | 44928711 |
| Variance | 842918.8569 |
| Memory size | 168.9 KiB |
| Value | Count | Frequency (%) | |
| 1300 | 138 | 0.6% | |
| 1400 | 135 | 0.6% | |
| 1440 | 133 | 0.6% | |
| 1660 | 129 | 0.6% | |
| 1010 | 129 | 0.6% | |
| 1800 | 129 | 0.6% | |
| 1820 | 128 | 0.6% | |
| 1480 | 125 | 0.6% | |
| 1720 | 125 | 0.6% | |
| 1540 | 124 | 0.6% | |
| Other values (1024) | 20302 | 94.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 370 | 1 | < 0.1% | |
| 380 | 1 | < 0.1% | |
| 390 | 1 | < 0.1% | |
| 410 | 1 | < 0.1% | |
| 420 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 13540 | 1 | < 0.1% | |
| 12050 | 1 | < 0.1% | |
| 10040 | 1 | < 0.1% | |
| 9890 | 1 | < 0.1% | |
| 9640 | 1 | < 0.1% |
sqft_living15
Numeric
| Distinct count | 777 |
|---|---|
| Unique (%) | 3.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1986.620318 |
|---|---|
| Minimum | 399 |
| Maximum | 6210 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 399 |
|---|---|
| 5-th percentile | 1140 |
| Q1 | 1490 |
| Median | 1840 |
| Q3 | 2360 |
| 95-th percentile | 3300 |
| Maximum | 6210 |
| Range | 5811 |
| Interquartile range | 870 |
Descriptive statistics
| Standard deviation | 685.2304719 |
|---|---|
| Coef of variation | 0.3449227141 |
| Kurtosis | 1.591732789 |
| Mean | 1986.620318 |
| MAD | 536.1565539 |
| Skewness | 1.106875397 |
| Sum | 42905039 |
| Variance | 469540.7996 |
| Memory size | 168.9 KiB |
| Value | Count | Frequency (%) | |
| 1540 | 197 | 0.9% | |
| 1440 | 195 | 0.9% | |
| 1560 | 192 | 0.9% | |
| 1500 | 180 | 0.8% | |
| 1460 | 169 | 0.8% | |
| 1580 | 167 | 0.8% | |
| 1610 | 166 | 0.8% | |
| 1800 | 166 | 0.8% | |
| 1720 | 166 | 0.8% | |
| 1620 | 164 | 0.8% | |
| Other values (767) | 19835 | 91.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 399 | 1 | < 0.1% | |
| 460 | 2 | < 0.1% | |
| 620 | 2 | < 0.1% | |
| 670 | 1 | < 0.1% | |
| 690 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 6210 | 1 | < 0.1% | |
| 6110 | 1 | < 0.1% | |
| 5790 | 6 | < 0.1% | |
| 5610 | 1 | < 0.1% | |
| 5600 | 1 | < 0.1% |
sqft_lot
Numeric
| Distinct count | 9776 |
|---|---|
| Unique (%) | 45.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 15099.40876 |
|---|---|
| Minimum | 520 |
| Maximum | 1651359 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 520 |
|---|---|
| 5-th percentile | 1800.8 |
| Q1 | 5040 |
| Median | 7618 |
| Q3 | 10685 |
| 95-th percentile | 43307.2 |
| Maximum | 1651359 |
| Range | 1650839 |
| Interquartile range | 5645 |
Descriptive statistics
| Standard deviation | 41412.63688 |
|---|---|
| Coef of variation | 2.742666122 |
| Kurtosis | 285.4958119 |
| Mean | 15099.40876 |
| MAD | 13825.41475 |
| Skewness | 13.07260357 |
| Sum | 326101931 |
| Variance | 1715006493 |
| Memory size | 168.9 KiB |
| Value | Count | Frequency (%) | |
| 5000 | 358 | 1.7% | |
| 6000 | 290 | 1.3% | |
| 4000 | 251 | 1.2% | |
| 7200 | 220 | 1.0% | |
| 7500 | 119 | 0.6% | |
| 4800 | 119 | 0.6% | |
| 4500 | 114 | 0.5% | |
| 8400 | 111 | 0.5% | |
| 9600 | 109 | 0.5% | |
| 3600 | 103 | 0.5% | |
| Other values (9766) | 19803 | 91.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 520 | 1 | < 0.1% | |
| 572 | 1 | < 0.1% | |
| 600 | 1 | < 0.1% | |
| 609 | 1 | < 0.1% | |
| 635 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1651359 | 1 | < 0.1% | |
| 1164794 | 1 | < 0.1% | |
| 1074218 | 1 | < 0.1% | |
| 1024068 | 1 | < 0.1% | |
| 982998 | 1 | < 0.1% |
sqft_lot15
Numeric
| Distinct count | 8682 |
|---|---|
| Unique (%) | 40.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 12758.28351 |
|---|---|
| Minimum | 651 |
| Maximum | 871200 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 651 |
|---|---|
| 5-th percentile | 2002.4 |
| Q1 | 5100 |
| Median | 7620 |
| Q3 | 10083 |
| 95-th percentile | 37045.2 |
| Maximum | 871200 |
| Range | 870549 |
| Interquartile range | 4983 |
Descriptive statistics
| Standard deviation | 27274.44195 |
|---|---|
| Coef of variation | 2.137783027 |
| Kurtosis | 151.3956625 |
| Mean | 12758.28351 |
| MAD | 10102.39581 |
| Skewness | 9.524361965 |
| Sum | 275540649 |
| Variance | 743895183.7 |
| Memory size | 168.9 KiB |
| Value | Count | Frequency (%) | |
| 5000 | 427 | 2.0% | |
| 4000 | 356 | 1.6% | |
| 6000 | 288 | 1.3% | |
| 7200 | 210 | 1.0% | |
| 4800 | 145 | 0.7% | |
| 7500 | 142 | 0.7% | |
| 8400 | 116 | 0.5% | |
| 4500 | 111 | 0.5% | |
| 3600 | 111 | 0.5% | |
| 5100 | 109 | 0.5% | |
| Other values (8672) | 19582 | 90.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 651 | 1 | < 0.1% | |
| 659 | 1 | < 0.1% | |
| 660 | 1 | < 0.1% | |
| 748 | 2 | < 0.1% | |
| 750 | 4 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 871200 | 1 | < 0.1% | |
| 858132 | 1 | < 0.1% | |
| 560617 | 1 | < 0.1% | |
| 438213 | 1 | < 0.1% | |
| 434728 | 1 | < 0.1% |
view
Numeric
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.3% |
| Missing (n) | 63 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.2338627287 |
|---|---|
| Minimum | 0 |
| Maximum | 4 |
| Zeros (%) | 89.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 4 |
| Range | 4 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.7656862012 |
|---|---|
| Coef of variation | 3.274083927 |
| Kurtosis | 10.91971254 |
| Mean | 0.2338627287 |
| MAD | 0.4218521331 |
| Skewness | 3.399525635 |
| Sum | 5036 |
| Variance | 0.5862753587 |
| Memory size | 168.9 KiB |
| Value | Count | Frequency (%) | |
| 0 | 19422 | 89.9% | |
| 2 | 957 | 4.4% | |
| 3 | 508 | 2.4% | |
| 1 | 330 | 1.5% | |
| 4 | 317 | 1.5% | |
| (Missing) | 63 | 0.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 19422 | 89.9% | |
| 1 | 330 | 1.5% | |
| 2 | 957 | 4.4% | |
| 3 | 508 | 2.4% | |
| 4 | 317 | 1.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 4 | 317 | 1.5% | |
| 3 | 508 | 2.4% | |
| 2 | 957 | 4.4% | |
| 1 | 330 | 1.5% | |
| 0 | 19422 | 89.9% |
waterfront
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 11.0% |
| Missing (n) | 2376 |
| 0 | |
|---|---|
| 1 | 146 |
| (Missing) | 2376 |
| Value | Count | Frequency (%) | |
| 0 | 19075 | 88.3% | |
| 1 | 146 | 0.7% | |
| (Missing) | 2376 | 11.0% |
yr_built
Numeric
| Distinct count | 116 |
|---|---|
| Unique (%) | 0.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1970.999676 |
|---|---|
| Minimum | 1900 |
| Maximum | 2015 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1900 |
|---|---|
| 5-th percentile | 1915 |
| Q1 | 1951 |
| Median | 1975 |
| Q3 | 1997 |
| 95-th percentile | 2011 |
| Maximum | 2015 |
| Range | 115 |
| Interquartile range | 46 |
Descriptive statistics
| Standard deviation | 29.37523413 |
|---|---|
| Coef of variation | 0.01490372347 |
| Kurtosis | -0.6576944258 |
| Mean | 1970.999676 |
| MAD | 24.56634737 |
| Skewness | -0.4694499765 |
| Sum | 42567680 |
| Variance | 862.9043803 |
| Memory size | 168.9 KiB |
| Value | Count | Frequency (%) | |
| 2014 | 559 | 2.6% | |
| 2006 | 453 | 2.1% | |
| 2005 | 450 | 2.1% | |
| 2004 | 433 | 2.0% | |
| 2003 | 420 | 1.9% | |
| 2007 | 417 | 1.9% | |
| 1977 | 417 | 1.9% | |
| 1978 | 387 | 1.8% | |
| 1968 | 381 | 1.8% | |
| 2008 | 367 | 1.7% | |
| Other values (106) | 17313 | 80.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1900 | 87 | 0.4% | |
| 1901 | 29 | 0.1% | |
| 1902 | 27 | 0.1% | |
| 1903 | 46 | 0.2% | |
| 1904 | 45 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2015 | 38 | 0.2% | |
| 2014 | 559 | 2.6% | |
| 2013 | 201 | 0.9% | |
| 2012 | 170 | 0.8% | |
| 2011 | 130 | 0.6% |
yr_renovated
Numeric
| Distinct count | 71 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 17.8% |
| Missing (n) | 3842 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 83.63677837 |
|---|---|
| Minimum | 0 |
| Maximum | 2015 |
| Zeros (%) | 78.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 2015 |
| Range | 2015 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 399.9464139 |
|---|---|
| Coef of variation | 4.781944279 |
| Kurtosis | 18.91954345 |
| Mean | 83.63677837 |
| MAD | 160.2641776 |
| Skewness | 4.573385242 |
| Sum | 1484971 |
| Variance | 159957.134 |
| Memory size | 168.9 KiB |
| Value | Count | Frequency (%) | |
| 0 | 17011 | 78.8% | |
| 2014 | 73 | 0.3% | |
| 2003 | 31 | 0.1% | |
| 2013 | 31 | 0.1% | |
| 2007 | 30 | 0.1% | |
| 2005 | 29 | 0.1% | |
| 2000 | 29 | 0.1% | |
| 1990 | 22 | 0.1% | |
| 2004 | 22 | 0.1% | |
| 2009 | 21 | 0.1% | |
| Other values (60) | 456 | 2.1% | |
| (Missing) | 3842 | 17.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 17011 | 78.8% | |
| 1934 | 1 | < 0.1% | |
| 1940 | 2 | < 0.1% | |
| 1944 | 1 | < 0.1% | |
| 1945 | 3 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2015 | 14 | 0.1% | |
| 2014 | 73 | 0.3% | |
| 2013 | 31 | 0.1% | |
| 2012 | 8 | < 0.1% | |
| 2011 | 9 | < 0.1% |
zipcode
Numeric
| Distinct count | 70 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 98077.95185 |
|---|---|
| Minimum | 98001 |
| Maximum | 98199 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 98001 |
|---|---|
| 5-th percentile | 98004 |
| Q1 | 98033 |
| Median | 98065 |
| Q3 | 98118 |
| 95-th percentile | 98177 |
| Maximum | 98199 |
| Range | 198 |
| Interquartile range | 85 |
Descriptive statistics
| Standard deviation | 53.51307235 |
|---|---|
| Coef of variation | 0.0005456177596 |
| Kurtosis | -0.8540048606 |
| Mean | 98077.95185 |
| MAD | 46.730101 |
| Skewness | 0.4053221913 |
| Sum | 2118189526 |
| Variance | 2863.648913 |
| Memory size | 168.9 KiB |
| Value | Count | Frequency (%) | |
| 98103 | 602 | 2.8% | |
| 98038 | 589 | 2.7% | |
| 98115 | 583 | 2.7% | |
| 98052 | 574 | 2.7% | |
| 98117 | 553 | 2.6% | |
| 98042 | 547 | 2.5% | |
| 98034 | 545 | 2.5% | |
| 98118 | 507 | 2.3% | |
| 98023 | 499 | 2.3% | |
| 98006 | 498 | 2.3% | |
| Other values (60) | 16100 | 74.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 98001 | 361 | 1.7% | |
| 98002 | 199 | 0.9% | |
| 98003 | 280 | 1.3% | |
| 98004 | 317 | 1.5% | |
| 98005 | 168 | 0.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 98199 | 317 | 1.5% | |
| 98198 | 280 | 1.3% | |
| 98188 | 136 | 0.6% | |
| 98178 | 262 | 1.2% | |
| 98177 | 255 | 1.2% |
First rows
| bathrooms | bedrooms | condition | date | floors | grade | id | lat | long | price | sqft_above | sqft_basement | sqft_living | sqft_living15 | sqft_lot | sqft_lot15 | view | waterfront | yr_built | yr_renovated | zipcode | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1.00 | 3 | 3 | 10/13/2014 | 1.0 | 7 | 7129300520 | 47.5112 | -122.257 | 221900.0 | 1180 | 0.0 | 1180 | 1340 | 5650 | 5650 | 0.0 | NaN | 1955 | 0.0 | 98178 |
| 1 | 2.25 | 3 | 3 | 12/9/2014 | 2.0 | 7 | 6414100192 | 47.7210 | -122.319 | 538000.0 | 2170 | 400.0 | 2570 | 1690 | 7242 | 7639 | 0.0 | 0.0 | 1951 | 1991.0 | 98125 |
| 2 | 1.00 | 2 | 3 | 2/25/2015 | 1.0 | 6 | 5631500400 | 47.7379 | -122.233 | 180000.0 | 770 | 0.0 | 770 | 2720 | 10000 | 8062 | 0.0 | 0.0 | 1933 | NaN | 98028 |
| 3 | 3.00 | 4 | 5 | 12/9/2014 | 1.0 | 7 | 2487200875 | 47.5208 | -122.393 | 604000.0 | 1050 | 910.0 | 1960 | 1360 | 5000 | 5000 | 0.0 | 0.0 | 1965 | 0.0 | 98136 |
| 4 | 2.00 | 3 | 3 | 2/18/2015 | 1.0 | 8 | 1954400510 | 47.6168 | -122.045 | 510000.0 | 1680 | 0.0 | 1680 | 1800 | 8080 | 7503 | 0.0 | 0.0 | 1987 | 0.0 | 98074 |
| 5 | 4.50 | 4 | 3 | 5/12/2014 | 1.0 | 11 | 7237550310 | 47.6561 | -122.005 | 1230000.0 | 3890 | 1530.0 | 5420 | 4760 | 101930 | 101930 | 0.0 | 0.0 | 2001 | 0.0 | 98053 |
| 6 | 2.25 | 3 | 3 | 6/27/2014 | 2.0 | 7 | 1321400060 | 47.3097 | -122.327 | 257500.0 | 1715 | ? | 1715 | 2238 | 6819 | 6819 | 0.0 | 0.0 | 1995 | 0.0 | 98003 |
| 7 | 1.50 | 3 | 3 | 1/15/2015 | 1.0 | 7 | 2008000270 | 47.4095 | -122.315 | 291850.0 | 1060 | 0.0 | 1060 | 1650 | 9711 | 9711 | NaN | 0.0 | 1963 | 0.0 | 98198 |
| 8 | 1.00 | 3 | 3 | 4/15/2015 | 1.0 | 7 | 2414600126 | 47.5123 | -122.337 | 229500.0 | 1050 | 730.0 | 1780 | 1780 | 7470 | 8113 | 0.0 | 0.0 | 1960 | 0.0 | 98146 |
| 9 | 2.50 | 3 | 3 | 3/12/2015 | 2.0 | 7 | 3793500160 | 47.3684 | -122.031 | 323000.0 | 1890 | 0.0 | 1890 | 2390 | 6560 | 7570 | 0.0 | 0.0 | 2003 | 0.0 | 98038 |
Last rows
| bathrooms | bedrooms | condition | date | floors | grade | id | lat | long | price | sqft_above | sqft_basement | sqft_living | sqft_living15 | sqft_lot | sqft_lot15 | view | waterfront | yr_built | yr_renovated | zipcode | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21587 | 2.50 | 3 | 3 | 8/25/2014 | 2.0 | 8 | 7852140040 | 47.5389 | -121.881 | 507250.0 | 2270 | 0.0 | 2270 | 2270 | 5536 | 5731 | 0.0 | NaN | 2003 | 0.0 | 98065 |
| 21588 | 2.00 | 3 | 3 | 1/26/2015 | 3.0 | 8 | 9834201367 | 47.5699 | -122.288 | 429000.0 | 1490 | 0.0 | 1490 | 1400 | 1126 | 1230 | 0.0 | 0.0 | 2014 | 0.0 | 98144 |
| 21589 | 2.50 | 4 | 3 | 10/14/2014 | 2.0 | 9 | 3448900210 | 47.5137 | -122.167 | 610685.0 | 2520 | 0.0 | 2520 | 2520 | 6023 | 6023 | NaN | 0.0 | 2014 | 0.0 | 98056 |
| 21590 | 3.50 | 4 | 3 | 3/26/2015 | 2.0 | 9 | 7936000429 | 47.5537 | -122.398 | 1010000.0 | 2600 | 910.0 | 3510 | 2050 | 7200 | 6200 | 0.0 | 0.0 | 2009 | 0.0 | 98136 |
| 21591 | 2.50 | 3 | 3 | 2/19/2015 | 2.0 | 8 | 2997800021 | 47.5773 | -122.409 | 475000.0 | 1180 | 130.0 | 1310 | 1330 | 1294 | 1265 | 0.0 | 0.0 | 2008 | 0.0 | 98116 |
| 21592 | 2.50 | 3 | 3 | 5/21/2014 | 3.0 | 8 | 263000018 | 47.6993 | -122.346 | 360000.0 | 1530 | 0.0 | 1530 | 1530 | 1131 | 1509 | 0.0 | 0.0 | 2009 | 0.0 | 98103 |
| 21593 | 2.50 | 4 | 3 | 2/23/2015 | 2.0 | 8 | 6600060120 | 47.5107 | -122.362 | 400000.0 | 2310 | 0.0 | 2310 | 1830 | 5813 | 7200 | 0.0 | 0.0 | 2014 | 0.0 | 98146 |
| 21594 | 0.75 | 2 | 3 | 6/23/2014 | 2.0 | 7 | 1523300141 | 47.5944 | -122.299 | 402101.0 | 1020 | 0.0 | 1020 | 1020 | 1350 | 2007 | 0.0 | 0.0 | 2009 | 0.0 | 98144 |
| 21595 | 2.50 | 3 | 3 | 1/16/2015 | 2.0 | 8 | 291310100 | 47.5345 | -122.069 | 400000.0 | 1600 | 0.0 | 1600 | 1410 | 2388 | 1287 | 0.0 | NaN | 2004 | 0.0 | 98027 |
| 21596 | 0.75 | 2 | 3 | 10/15/2014 | 2.0 | 7 | 1523300157 | 47.5941 | -122.299 | 325000.0 | 1020 | 0.0 | 1020 | 1020 | 1076 | 1357 | 0.0 | 0.0 | 2008 | 0.0 | 98144 |